
/*
*Released on 28th June 2008.
*Any violations can be reported at paritosh@wikiocean.net
*What is treated as violations can be found at www.wikiocean.net/ppl1-voilations*
******************************************************************************
* The contents of this file are subject to POOL Public License 1.0 and later.
* POOL Public License is based on Affero GPL v3 and additional conditions.
* ("License"); You may not use this file except in compliance with the License
* You may obtain a copy of the Affero GPL v3 License at http://www.gnu.org/licenses/agpl.html
* You may obtain a copy of the POOL Public License 1.0 or later at www.wikiocean.net/license/ppl.html
* Software distributed under POOL Public License 1.0 is distributed on an "AS IS" basis,
* WITHOUT WARRANTY OF ANY KIND, either express or implied. See the License for
* the specific language governing rights and limitations under the License.
* The Initial Developer of the Original Code is Paritosh Pungaliya (C) 2008. All Rights Reserved.
******************************************************************************
* Objective of the additional terms (license)
* 1) Is to extend the software freedom to freedom to work.
* 2) To ensure that knowledge is free from monopoly of agencies.
* 3) To avoid a situation where big corporate or investor can buy out free software groups and companies and then start milking the communities built around it.
* (this trend can be seen how the freedom is curtailed in companies that get Venture Capital funding.)
******************************************************************************
*/

package  query.report;

import java.util.Hashtable;
import java.util.Vector;

import logger.PoolLogger;
import dbmanager.DBManager;
import dbmanager.GetIdName;

public class Storage implements ReportInterface 
{
	String ReportName;
	String process;
	String value;
	//DBManager database;
	String buffer[];
	String Object;
	GetIdName gid;
	String PATH="path";
	String key;
	String typeofreport;
	Hashtable<Object, Object> Reportmap = new Hashtable<Object, Object>();
	PoolLogger pl;
	
	public Storage() {
		// logger
		pl = (PoolLogger) PoolLogger.getLogger(this.getClass().getName());
	}
	
	public void setProcess(String process) 
	{
		this.process = process;	
	}

	public void setValue(String value) 
	{
		this.value = value;
	}

	public String[] getBuffer() 
	{
		return buffer;
	}

	public void getResult() 
	{
		Vector<Object> Field =new  Vector<Object>();
		String heading[] =null;
		if(buffer.length>0)
		{
			heading = buffer[0].split("\t");
			for(int i=0;i<heading.length;i++)
				Field.add(heading[i].trim());
			if(!process.equals("mod"))
				DBManager.createTable(ReportName, Field);
		}
		try {
			if(process.equals("mod"))
			{
				DBManager.getDelete("Drop table '"+ReportName+"'");	
				DBManager.createTable(ReportName, Field);
			}
		} catch (Exception e1) {
			// TODO Auto-generated catch block
			e1.printStackTrace();
		}	
		for(int i=buffer.length-1;i>0;i--)
		{
			Hashtable<Object, Object> table= new Hashtable<Object, Object>();
			try {
				String splitbuffer[] = buffer[i].split("\t");
				table = new Hashtable<Object, Object>();
				for(int k=0;k<splitbuffer.length;k++)
				{
					try {
						table.put(heading[k].toLowerCase().trim(), splitbuffer[k]);
					} catch (Exception e) {
						e.printStackTrace();
					}
				}
				DBManager.getInsert(ReportName, table);
			} catch (Exception e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
			
		}
	}

	public void setObject(String Object) 
	{
		this.Object = Object;
	}

	public void initPool() 
	{
		gid = new GetIdName();
		PATH = gid.getId(PATH);
	}

	public String getReportName() 
	{
		return ReportName;
	}

	public void setReportName(String ReportName) 
	{
		this.ReportName = ReportName;
	}
	public void setBuffer(String[] buffer)
	{
		this.buffer = buffer;
	}

	public void addReport() 
	{
		getResult();
	}

	public void updateReport() 
	{
		getResult(); 
	}

	public String getKey() 
	{
		return key;
	}

	public void setKey(String key) 
	{
		this.key = key;
	}

	
	public void initializeData() 
	{
		
	}

	public Hashtable<java.lang.Object, java.lang.Object> getReportMap() 
	{
		return Reportmap;
	}

	public void setReportmap(Hashtable<java.lang.Object, java.lang.Object> table) 
	{
		this.Reportmap = table;
	}

	public String gettypeofreport() 
	{
		return typeofreport;
	}

	public void settypeofreport(String typeofreport) 
	{
		if(!typeofreport.equals(null))
		this.typeofreport = typeofreport;
		else
			typeofreport="autoupdate";
	}

	public void setrepoton(String reporton) 
	{	
	}

	public String getProcess() 
	{
		return process;
	}

	
	public void setConditionmap(Vector<Object> table) 
	{
		
	}

}
